Analysis of Big Tech Stock Prices

INFO 523 - Spring 2023 - Project 1

Christian Ortmann, Roxana Akbarsharifi, Abhishek Kumar, Shashank Yadav, Gorantla Sai Laasya, Divya Liladhar Dhole

Introducing the Dataset

  • Data was sourced from Tidy Tuesday, which pulled from Kaggle
  • Dataset consists of 14 Big Tech stocks and their respective economic metrics from 2010 to 2022
  • Contains some missing data points where companies were listed after 2010
  • Motivated to make low risk financial decision by analyzing past stock market trends

Question 1: How do stock prices change over time based on basic economic metrics

Line Plot and Bar Plot

Insights

Question 2:

Question-2 Backwards verification: if we invested x amount of dollars in 2010, how much would it be worth in 2022, when would be a good/bad time to pull investment out of the market

Insights

  • We observed that Tesla’s stock price experienced significant growth from 2012 to 2022, increasing by a factor of 10 during that period when normalized to a particular reference point.

  • The 50-DMA of the stock price consistently exceeds the 200-DMA.

  • Considering the Netflix

Normalized Stock Price over Time

50, 200 Day Moving Averages

Insights

Conclusion

Thank You!